﻿/********************************************************************************************************************
* Author:	Aris Michail																							*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getPublicCategories" that returns		*
*			all public categories.																					*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getPublicCategories]
AS
	SELECT ID, Name
	FROM Categories
	WHERE Categories.IsPrivate = '0' and Categories.IsDeleted != '1'
RETURN 0